会计规则
概述
重启,重启,重启
账套/账簿
单账套/多账套
多账套实例1
多账套实例2
实体的账套设置
账户结构
关于平衡段
维度的组织指定
账户组合
编辑科目时,系统同时更新账户组合值
导入科目无法自动更新账户组合的描述和名称
select a.Combination ,a.Description, b.value, b.name, strpos(a.Combination, b.value) from C_ValidCombination a
join C_ElementValue b on a.Account_ID = C_ElementValue_ID where strpos(a.Combination, b.value) = 0
导入科目后更新账户组合(需根据自己维度更改字符串)
update C_ValidCombination a
set Combination= '*-' || b.value || '-_-_-_' , description = '*-' || b.name || '-_-_-_' from
C_ElementValue b where a.Account_ID = b.C_ElementValue_ID and strpos(a.Combination, b.value) = 0
更新事务表的科目id
update Fact_Acct set Account_ID =1001058 where Account_ID = 1000493;
update Fact_Acct_Summary set Account_ID =1001058 where Account_ID = 1000493;
update Fact_Reconciliation set fact_acct_id =1001058 where fact_acct_id = 1000493;
update GL_JournalLine set Account_ID =1001058 where Account_ID = 1000493;
update GL_JournalLine set c_validcombination_id =1000555 where c_validcombination_id = 1000551;